Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | SaleReturnTaxLineItem(TR_LTM_SLS_RTN_TX) |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | SaleReturnTaxLineItem(TR_LTM_SLS_RTN_TX) |
SalesTaxSequenceNumber (FK)(PK) | A sequentially assigned number used to ensure a unique identity for SaleReturnTaxLineItem instances. | IC_SLS_TX_SQN_NMB | LineNumber | smallint | SaleReturnTaxLineItem(TR_LTM_SLS_RTN_TX) |
IssuedToPartyID (FK) | A unique, system assigned identity for a Party. | ID_PRTY_ISS_TO | Identity | integer | TaxCertificate(PA_TX_CF) |
TaxCertificateSequenceNumber (FK) | A sequential counter used to uniquely identify a tax certificate for a specific party. | AI_PA_TX_CF | LineNumber | smallint | TaxCertificate(PA_TX_CF) |
ExemptTaxableAmount | The Taxable amount which the customer would've been liable to pay tax on had they not been granted this exemption. | MO_EXM_TXBL | MoneyShortRetail | decimal(7,2) | |
ExemptTaxAmount | The amount of tax that the customer would've been liable to pay had thus TaxExemption not been granted. | MO_EXM_TX | MoneyShortRetail | decimal(7,2) | |
ReasonCode (FK) | A retailer assigned code denoting why this TaxExemption was granted. | CD_RSN | Code | varchar(20) | Reason(CO_CD_RSN) |
CustomerExemptionID | Identifier presented by Customer to get this tax exemption. Not used if Customer presents an individualised tax exemption certificate. e.g. Flight Number in Duty Free stores at Airport. | ID_EXM_CT | IdentityAlphaNumeric | varchar(20) | |
CertificateNumber | A unique identifier taken from the TaxExemption Certificate that the customer presented in order to get this Tax Exemption. | ID_CF_TX_EXM | IdentityAlphaNumeric | varchar(20) | |
CertificateHolderName | The Customer name taken from the TaxExemption Certificate that the customer presented in order to get this Tax Exemption. | NM_CF_HLDR | Name | varchar(40) | |